﻿/*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using SqliteORM;
using System.Security.Cryptography;
using System.Text;

namespace ChgDoc.Entity
{
    [Table]
    public class Login : TableBase<Login>
    {
        [PrimaryKey( true )]
        public long Id { get; set; }

        [Field( IsCaseInsensitive = true )]
        public string Email { get; set; }

        [Field]
        public string EncPassword { get; set; }

        public static string Encode( string password )
        {
            return Convert.ToBase64String( (new SHA1CryptoServiceProvider()).ComputeHash( Encoding.ASCII.GetBytes( "9X" + password + "!") ) ).Replace( "+", "." );		
        }

        private Authentication _authentication ;
        public Authentication Authentication
        {
            get
            {
                return (_authentication ?? (_authentication = Authentication.ForMechanism( "site", Id.ToString() )));
            }
        }

        public static Login Find( string email, string password )
        {
            return Get( ad => ad.Select().Where( Where.And( Where.Equal( "Email", email ), Where.Equal( "EncPassword", Encode( password ) ) ) ).FirstOrDefault() );
        }

        public static List<Login> ReadAll()
        {
            return Get( ad => ad.Select().ToList() );
        }

        internal static void Delete( long id )
        {
            Do( ad => ad.Delete( id ) );
        }
    }
}